Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL
1) Aggregate Functions
2) Backup Load
3) Command Mysql
4) Cursor
5) Data Type
6) Database
7) Date Time
8) Engine
9) Event
10) Flow Control
11) Fulltext Search
12) Function
13) Geometric
14) Insert Delete Update
15) Internationalization
16) Join
17) Key
18) Math
19) Procedure Function
20) Regular Expression
21) Select Clause
22) String
23) Table Index
24) Transaction
25) Trigger
26) User Permission
27) View
28) Where Clause
29) XML

Where Clause
1) A WHERE clause that contains two expressions (conditions)
2) Add a WHERE clause that looks for NULL values in the book column that is named in the ON clause
3) Add an expression to the WHERE clause that explicitly excludes the reference
4) Adds an additional condition to the WHERE clause and the calculated columns must have a total greater than 20
5) An OR operator
6) And 1
7) AND and OR may be intermixed
8) Calculation in WHERE clause
9) Change localhost to the name of the machine where youll be working
10) Check day name in where clause
11) Combine condition with OR
12) Combine conditions
13) Combine conditions in select clause
14) Combining WHERE Conditions
15) Compare and calculate in Where clause
16) Compare the results from two statements
17) Compare two conditions
18) Define multiple conditions in a clause
19) Do Calculation in Where and order
20) Get the number of items for each color where the price exceeds 150 00 and when there is more than 1 item for t
21) Getting the List of Products That Are on Catalog Promotion
22) Not equal in where
23) Put the entire original expression in parentheses and negate the whole thing with NOT
24) Retrieve the name of the customer placing order 4
25) Searches for surnames that have an e anywhere in the name and then end with an e
26) SELECT statement includes three expressions connected with an AND operator and an OR operator
27) SELECT statement includes two expressions within the WHERE clause
28) Show all records where the color is not Silver or the price is below 100 00
29) Show all records where the color is Silver and the price is above 100 00
30) Show records where make is Krups, Gaggia or DeLonghi and the model is not TSK-182 or EC410
31) The AND construct means that both clauses must be true
32) To display the author who painted each book
33) To put first those records where people sent messages to themselves
34) Use AND for int value
35) Use AND to combine conditions
36) Use CURRENT_DATE in where clause
37) Use where clause the narrow down results
38) Using a WHERE clause that matches up values in the author ID column
39) Using Where Conditions
40) Where clause
41) WHERE Clause Comparisons
42) WHERE clauses can test multiple conditions
43) WHERE TRUE OR FALSE